{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "![Vanna AI](https://img.vanna.ai/vanna-ask.svg)\n",
    "\n",
    "The following notebook goes through the process of connecting to your postgres database and running sql queries usig Vanna AI. Here we use a demo connection(https://rnacentral.org/help/public-database)\n",
    "\n",
    "# Install Vanna\n",
    "First we install Vanna from [PyPI](https://pypi.org/project/vanna/) and import it.\n",
    "Here, we'll install vanna with extra postgres. If you're using a different database, you'll need to install the appropriate extras."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "%pip install vanna[postgres]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import vanna as vn"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Set Database Connection\n",
    "These details are only referenced within your notebook. These database credentials are never sent to Vanna's severs.\n",
    "You need to set:\n",
    "`Host`\n",
    "`DATABASE`\n",
    "`PG_USER`\n",
    "`PASSWORD`\n",
    "`PORT`\n",
    "in your environment. Example connection you can use: `HOST=hh-pgsql-public.ebi.ac.uk` `DATABASE=pfmegrnargs` `PG_USER=reader` `PASSWORD=NWDMCE5xdipIjRrp` `PORT=5432`"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "vn.connect_to_postgres()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Or we can provide credentials as parameters `host` `dbname` `user` `password` `port` in above method."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Get Results\n",
    "This gets the SQL run it and prints it's result as a dataframe. Note that we use your connection string to execute the SQL on your warehouse from your local instance. Your connection nor your data gets sent to Vanna's servers. For more info on how Vanna works, [see this post](https://medium.com/vanna-ai/how-vanna-works-how-to-train-it-data-security-8d8f2008042). We will be using example sql below. Note: below SQL only works for the above demo connection."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>timestamp</th>\n",
       "      <th>userstamp</th>\n",
       "      <th>descr</th>\n",
       "      <th>current_release</th>\n",
       "      <th>full_descr</th>\n",
       "      <th>alive</th>\n",
       "      <th>for_release</th>\n",
       "      <th>display_name</th>\n",
       "      <th>project_id</th>\n",
       "      <th>avg_length</th>\n",
       "      <th>min_length</th>\n",
       "      <th>max_length</th>\n",
       "      <th>num_sequences</th>\n",
       "      <th>num_organisms</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>5</td>\n",
       "      <td>2017-05-17 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>VEGA</td>\n",
       "      <td>98</td>\n",
       "      <td>VEGA</td>\n",
       "      <td>N</td>\n",
       "      <td>None</td>\n",
       "      <td>VEGA</td>\n",
       "      <td>PRJEB4568</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>ENA</td>\n",
       "      <td>731</td>\n",
       "      <td>ENA</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>ENA</td>\n",
       "      <td>None</td>\n",
       "      <td>412.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>900074.0</td>\n",
       "      <td>12086180</td>\n",
       "      <td>814855</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>26</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>GENCODE</td>\n",
       "      <td>450</td>\n",
       "      <td>GENCODE</td>\n",
       "      <td>N</td>\n",
       "      <td>None</td>\n",
       "      <td>GENCODE</td>\n",
       "      <td>None</td>\n",
       "      <td>889.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>205012.0</td>\n",
       "      <td>47677</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>SRPDB</td>\n",
       "      <td>732</td>\n",
       "      <td>SRPDB</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>SRPDB</td>\n",
       "      <td>PRJEB4384</td>\n",
       "      <td>173.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>533.0</td>\n",
       "      <td>503</td>\n",
       "      <td>684</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>15</td>\n",
       "      <td>2017-05-02 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>WORMBASE</td>\n",
       "      <td>735</td>\n",
       "      <td>WormBase</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>WormBase</td>\n",
       "      <td>PRJNA13758</td>\n",
       "      <td>174.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>84141.0</td>\n",
       "      <td>26116</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>24</td>\n",
       "      <td>2017-05-02 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>FLYBASE</td>\n",
       "      <td>739</td>\n",
       "      <td>FlyBase</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>FlyBase</td>\n",
       "      <td>PRJ_FLY</td>\n",
       "      <td>765.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>21216.0</td>\n",
       "      <td>4210</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>14</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>TAIR</td>\n",
       "      <td>720</td>\n",
       "      <td>TAIR</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>TAIR</td>\n",
       "      <td>PRJ_TAIR</td>\n",
       "      <td>384.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>6227.0</td>\n",
       "      <td>4406</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>RFAM</td>\n",
       "      <td>635</td>\n",
       "      <td>RFAM</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>Rfam</td>\n",
       "      <td>None</td>\n",
       "      <td>135.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>11047.0</td>\n",
       "      <td>1872081</td>\n",
       "      <td>14735</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>25</td>\n",
       "      <td>2017-05-11 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>ENSEMBL</td>\n",
       "      <td>721</td>\n",
       "      <td>Ensembl</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>Ensembl</td>\n",
       "      <td>None</td>\n",
       "      <td>908.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>347561.0</td>\n",
       "      <td>1294678</td>\n",
       "      <td>264</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>52</td>\n",
       "      <td>2022-12-21 11:20:36.071013</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>RIBOCENTRE</td>\n",
       "      <td>729</td>\n",
       "      <td>Ribocentre</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>Ribocentre</td>\n",
       "      <td>None</td>\n",
       "      <td>67.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>1619.0</td>\n",
       "      <td>151770</td>\n",
       "      <td>5536</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>53</td>\n",
       "      <td>2023-01-24 11:56:51.648817</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>EVLNCRNAS</td>\n",
       "      <td>730</td>\n",
       "      <td>EVLncRNAs</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>EVLncRNAs</td>\n",
       "      <td>None</td>\n",
       "      <td>2311.0</td>\n",
       "      <td>199.0</td>\n",
       "      <td>205012.0</td>\n",
       "      <td>933</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>6</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>TMRNA_WEB</td>\n",
       "      <td>414</td>\n",
       "      <td>tmRNA Website</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>tmRNA Website</td>\n",
       "      <td>PRJEB4570</td>\n",
       "      <td>335.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>644.0</td>\n",
       "      <td>2857</td>\n",
       "      <td>7560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>51</td>\n",
       "      <td>2022-09-22 15:14:59.500143</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>EXPRESSION_ATLAS</td>\n",
       "      <td>636</td>\n",
       "      <td>Expression Atlas</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>Expression Atlas</td>\n",
       "      <td>None</td>\n",
       "      <td>953.0</td>\n",
       "      <td>72.0</td>\n",
       "      <td>32709.0</td>\n",
       "      <td>11030</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>35</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>ENSEMBL_PROTISTS</td>\n",
       "      <td>724</td>\n",
       "      <td>Ensembl Protists</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>Ensembl Protists</td>\n",
       "      <td>None</td>\n",
       "      <td>212.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>7940.0</td>\n",
       "      <td>5261</td>\n",
       "      <td>32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>36</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>ENSEMBL_FUNGI</td>\n",
       "      <td>725</td>\n",
       "      <td>Ensembl Fungi</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>Ensembl Fungi</td>\n",
       "      <td>None</td>\n",
       "      <td>210.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>16569.0</td>\n",
       "      <td>15817</td>\n",
       "      <td>62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>22</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>MODOMICS</td>\n",
       "      <td>92</td>\n",
       "      <td>Modomics</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>Modomics</td>\n",
       "      <td>None</td>\n",
       "      <td>140.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>5025.0</td>\n",
       "      <td>319</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>20</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>LNCIPEDIA</td>\n",
       "      <td>612</td>\n",
       "      <td>LNCipedia</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>LNCipedia</td>\n",
       "      <td>None</td>\n",
       "      <td>1534.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>152544.0</td>\n",
       "      <td>126876</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>28</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>RGD</td>\n",
       "      <td>194</td>\n",
       "      <td>Rat Genome Database</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>RGD</td>\n",
       "      <td>None</td>\n",
       "      <td>2340.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>27956.0</td>\n",
       "      <td>11124</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>27</td>\n",
       "      <td>2017-10-23 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>MGI</td>\n",
       "      <td>174</td>\n",
       "      <td>Mouse Genome Database</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>MGI</td>\n",
       "      <td>None</td>\n",
       "      <td>851.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>84395.0</td>\n",
       "      <td>16719</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>50</td>\n",
       "      <td>2022-08-16 15:52:33.990145</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>PLNCDB</td>\n",
       "      <td>606</td>\n",
       "      <td>PLncDB</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>PLncDB</td>\n",
       "      <td>None</td>\n",
       "      <td>6659.0</td>\n",
       "      <td>199.0</td>\n",
       "      <td>985945.0</td>\n",
       "      <td>936926</td>\n",
       "      <td>80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>49</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>RIBOVISION</td>\n",
       "      <td>560</td>\n",
       "      <td>RiboVision</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>RiboVision</td>\n",
       "      <td>None</td>\n",
       "      <td>1676.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>5070.0</td>\n",
       "      <td>36</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>42</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>INTACT</td>\n",
       "      <td>740</td>\n",
       "      <td>IntAct</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>IntAct</td>\n",
       "      <td>None</td>\n",
       "      <td>705.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>93092.0</td>\n",
       "      <td>386</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>48</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>PSICQUIC</td>\n",
       "      <td>632</td>\n",
       "      <td>PSICQUIC</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>PSICQUIC</td>\n",
       "      <td>None</td>\n",
       "      <td>2251.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>84395.0</td>\n",
       "      <td>95</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>34</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>ENSEMBL_METAZOA</td>\n",
       "      <td>723</td>\n",
       "      <td>Ensembl Metazoa</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>Ensembl Metazoa</td>\n",
       "      <td>None</td>\n",
       "      <td>712.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>46956.0</td>\n",
       "      <td>285241</td>\n",
       "      <td>152</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>40</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>MALACARDS</td>\n",
       "      <td>726</td>\n",
       "      <td>MalaCards</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>MalaCards</td>\n",
       "      <td>None</td>\n",
       "      <td>1861.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>220253.0</td>\n",
       "      <td>57129</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>41</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>GENECARDS</td>\n",
       "      <td>727</td>\n",
       "      <td>MalaCards</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>GeneCards</td>\n",
       "      <td>None</td>\n",
       "      <td>1301.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>347561.0</td>\n",
       "      <td>515365</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>47</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>ENSEMBL_GENCODE</td>\n",
       "      <td>728</td>\n",
       "      <td>ENSEMBL_GENCODE</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>Ensembl/GENCODE</td>\n",
       "      <td>None</td>\n",
       "      <td>1274.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>347561.0</td>\n",
       "      <td>76095</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>19</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>DICTYBASE</td>\n",
       "      <td>86</td>\n",
       "      <td>dictyBase</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>dictyBase</td>\n",
       "      <td>PRJ_DICTY</td>\n",
       "      <td>82.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>1060.0</td>\n",
       "      <td>149</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>12</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>SNOPY</td>\n",
       "      <td>511</td>\n",
       "      <td>snOPY</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>snOPY</td>\n",
       "      <td>PRJEB8122</td>\n",
       "      <td>117.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>1004.0</td>\n",
       "      <td>2501</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>46</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>PIRBASE</td>\n",
       "      <td>485</td>\n",
       "      <td>piRBase</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>piRBase</td>\n",
       "      <td>None</td>\n",
       "      <td>28.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>200827</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>45</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>CRW</td>\n",
       "      <td>593</td>\n",
       "      <td>CRW</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>CRW</td>\n",
       "      <td>None</td>\n",
       "      <td>1365.0</td>\n",
       "      <td>107.0</td>\n",
       "      <td>4381.0</td>\n",
       "      <td>934</td>\n",
       "      <td>685</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>8</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>GTRNADB</td>\n",
       "      <td>733</td>\n",
       "      <td>GtRNAdb</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>GtRNAdb</td>\n",
       "      <td>PRJEB5173</td>\n",
       "      <td>76.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>356.0</td>\n",
       "      <td>93098</td>\n",
       "      <td>4337</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>9</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>REFSEQ</td>\n",
       "      <td>719</td>\n",
       "      <td>RefSeq</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>RefSeq</td>\n",
       "      <td>None</td>\n",
       "      <td>637.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>91671.0</td>\n",
       "      <td>107976</td>\n",
       "      <td>22247</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>31</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>ENSEMBL_PLANTS</td>\n",
       "      <td>722</td>\n",
       "      <td>Ensembl Plants</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>Ensembl Plants</td>\n",
       "      <td>None</td>\n",
       "      <td>279.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>79788.0</td>\n",
       "      <td>76428</td>\n",
       "      <td>59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>43</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>SNORNADB</td>\n",
       "      <td>446</td>\n",
       "      <td>snoRNA Database</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>snoRNA Database</td>\n",
       "      <td>None</td>\n",
       "      <td>50.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>74.0</td>\n",
       "      <td>680</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>10</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>RDP</td>\n",
       "      <td>85</td>\n",
       "      <td>RDP</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>RDP</td>\n",
       "      <td>None</td>\n",
       "      <td>1536.0</td>\n",
       "      <td>1337.0</td>\n",
       "      <td>1600.0</td>\n",
       "      <td>4779</td>\n",
       "      <td>2487</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>7</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>LNCRNADB</td>\n",
       "      <td>464</td>\n",
       "      <td>lncRNAdb</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>lncRNAdb</td>\n",
       "      <td>PRJEB6238</td>\n",
       "      <td>3086.0</td>\n",
       "      <td>61.0</td>\n",
       "      <td>32753.0</td>\n",
       "      <td>62</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>39</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>MIRGENEDB</td>\n",
       "      <td>559</td>\n",
       "      <td>MirGeneDB</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>MirGeneDB</td>\n",
       "      <td>None</td>\n",
       "      <td>41.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>282.0</td>\n",
       "      <td>18901</td>\n",
       "      <td>75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>17</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>SILVA</td>\n",
       "      <td>610</td>\n",
       "      <td>SILVA</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>SILVA</td>\n",
       "      <td>None</td>\n",
       "      <td>1080.0</td>\n",
       "      <td>300.0</td>\n",
       "      <td>4997.0</td>\n",
       "      <td>8193988</td>\n",
       "      <td>665540</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>30</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>ZWD</td>\n",
       "      <td>615</td>\n",
       "      <td>ZWD</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>ZWD</td>\n",
       "      <td>None</td>\n",
       "      <td>86.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>951.0</td>\n",
       "      <td>44332</td>\n",
       "      <td>6763</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>33</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>LNCBOOK</td>\n",
       "      <td>616</td>\n",
       "      <td>LncBook</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>LncBook</td>\n",
       "      <td>None</td>\n",
       "      <td>1686.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>205012.0</td>\n",
       "      <td>322552</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>11</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>PDBE</td>\n",
       "      <td>734</td>\n",
       "      <td>PDBe</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>PDBe</td>\n",
       "      <td>None</td>\n",
       "      <td>591.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>19000.0</td>\n",
       "      <td>3760</td>\n",
       "      <td>382</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>16</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>SGD</td>\n",
       "      <td>736</td>\n",
       "      <td>SGD</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>SGD</td>\n",
       "      <td>PRJ_SGD</td>\n",
       "      <td>243.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>6858.0</td>\n",
       "      <td>212</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>18</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>POMBASE</td>\n",
       "      <td>737</td>\n",
       "      <td>PomBase</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>PomBase</td>\n",
       "      <td>PRJNA13836</td>\n",
       "      <td>179.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>3485.0</td>\n",
       "      <td>200</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>23</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>HGNC</td>\n",
       "      <td>738</td>\n",
       "      <td>HUGO Gene Nomenclature Committee</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>HGNC</td>\n",
       "      <td>None</td>\n",
       "      <td>1058.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>205012.0</td>\n",
       "      <td>8438</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>44</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>ZFIN</td>\n",
       "      <td>741</td>\n",
       "      <td>ZFIN</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>ZFIN</td>\n",
       "      <td>None</td>\n",
       "      <td>907.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>13525.0</td>\n",
       "      <td>1025</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>37</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>SNODB</td>\n",
       "      <td>444</td>\n",
       "      <td>snoDB</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>snoDB</td>\n",
       "      <td>None</td>\n",
       "      <td>117.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>791.0</td>\n",
       "      <td>1970</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>13</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>GREENGENES</td>\n",
       "      <td>71</td>\n",
       "      <td>Greengenes</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>Greengenes</td>\n",
       "      <td>None</td>\n",
       "      <td>1403.0</td>\n",
       "      <td>1253.0</td>\n",
       "      <td>2368.0</td>\n",
       "      <td>1004892</td>\n",
       "      <td>92684</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>38</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>5SRRNADB</td>\n",
       "      <td>387</td>\n",
       "      <td>5SrRNAdb</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>5SrRNAdb</td>\n",
       "      <td>None</td>\n",
       "      <td>120.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>180.0</td>\n",
       "      <td>9487</td>\n",
       "      <td>7158</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>32</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>LNCBASE</td>\n",
       "      <td>248</td>\n",
       "      <td>LncBase</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>LncBase</td>\n",
       "      <td>None</td>\n",
       "      <td>22.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>1151</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>29</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>TARBASE</td>\n",
       "      <td>223</td>\n",
       "      <td>TarBase</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>TarBase</td>\n",
       "      <td>None</td>\n",
       "      <td>22.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>1291</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>4</td>\n",
       "      <td>2017-05-01 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>MIRBASE</td>\n",
       "      <td>435</td>\n",
       "      <td>MIRBASE</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>miRBase</td>\n",
       "      <td>PRJEB4451</td>\n",
       "      <td>55.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>2354.0</td>\n",
       "      <td>65389</td>\n",
       "      <td>271</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>21</td>\n",
       "      <td>2017-05-02 00:00:00.000000</td>\n",
       "      <td>RNACEN</td>\n",
       "      <td>NONCODE</td>\n",
       "      <td>146</td>\n",
       "      <td>NONCODE</td>\n",
       "      <td>Y</td>\n",
       "      <td>None</td>\n",
       "      <td>NONCODE</td>\n",
       "      <td>None</td>\n",
       "      <td>1130.0</td>\n",
       "      <td>201.0</td>\n",
       "      <td>244296.0</td>\n",
       "      <td>234669</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    id                  timestamp userstamp             descr  \\\n",
       "0    5 2017-05-17 00:00:00.000000    RNACEN              VEGA   \n",
       "1    1 2017-05-01 00:00:00.000000    RNACEN               ENA   \n",
       "2   26 2017-05-01 00:00:00.000000    RNACEN           GENCODE   \n",
       "3    3 2017-05-01 00:00:00.000000    RNACEN             SRPDB   \n",
       "4   15 2017-05-02 00:00:00.000000    RNACEN          WORMBASE   \n",
       "5   24 2017-05-02 00:00:00.000000    RNACEN           FLYBASE   \n",
       "6   14 2017-05-01 00:00:00.000000    RNACEN              TAIR   \n",
       "7    2 2017-05-01 00:00:00.000000    RNACEN              RFAM   \n",
       "8   25 2017-05-11 00:00:00.000000    RNACEN           ENSEMBL   \n",
       "9   52 2022-12-21 11:20:36.071013    RNACEN        RIBOCENTRE   \n",
       "10  53 2023-01-24 11:56:51.648817    RNACEN         EVLNCRNAS   \n",
       "11   6 2017-05-01 00:00:00.000000    RNACEN         TMRNA_WEB   \n",
       "12  51 2022-09-22 15:14:59.500143    RNACEN  EXPRESSION_ATLAS   \n",
       "13  35 2017-05-01 00:00:00.000000    RNACEN  ENSEMBL_PROTISTS   \n",
       "14  36 2017-05-01 00:00:00.000000    RNACEN     ENSEMBL_FUNGI   \n",
       "15  22 2017-05-01 00:00:00.000000    RNACEN          MODOMICS   \n",
       "16  20 2017-05-01 00:00:00.000000    RNACEN         LNCIPEDIA   \n",
       "17  28 2017-05-01 00:00:00.000000    RNACEN               RGD   \n",
       "18  27 2017-10-23 00:00:00.000000    RNACEN               MGI   \n",
       "19  50 2022-08-16 15:52:33.990145    RNACEN            PLNCDB   \n",
       "20  49 2017-05-01 00:00:00.000000    RNACEN        RIBOVISION   \n",
       "21  42 2017-05-01 00:00:00.000000    RNACEN            INTACT   \n",
       "22  48 2017-05-01 00:00:00.000000    RNACEN          PSICQUIC   \n",
       "23  34 2017-05-01 00:00:00.000000    RNACEN   ENSEMBL_METAZOA   \n",
       "24  40 2017-05-01 00:00:00.000000    RNACEN         MALACARDS   \n",
       "25  41 2017-05-01 00:00:00.000000    RNACEN         GENECARDS   \n",
       "26  47 2017-05-01 00:00:00.000000    RNACEN   ENSEMBL_GENCODE   \n",
       "27  19 2017-05-01 00:00:00.000000    RNACEN         DICTYBASE   \n",
       "28  12 2017-05-01 00:00:00.000000    RNACEN             SNOPY   \n",
       "29  46 2017-05-01 00:00:00.000000    RNACEN           PIRBASE   \n",
       "30  45 2017-05-01 00:00:00.000000    RNACEN               CRW   \n",
       "31   8 2017-05-01 00:00:00.000000    RNACEN           GTRNADB   \n",
       "32   9 2017-05-01 00:00:00.000000    RNACEN            REFSEQ   \n",
       "33  31 2017-05-01 00:00:00.000000    RNACEN    ENSEMBL_PLANTS   \n",
       "34  43 2017-05-01 00:00:00.000000    RNACEN          SNORNADB   \n",
       "35  10 2017-05-01 00:00:00.000000    RNACEN               RDP   \n",
       "36   7 2017-05-01 00:00:00.000000    RNACEN          LNCRNADB   \n",
       "37  39 2017-05-01 00:00:00.000000    RNACEN         MIRGENEDB   \n",
       "38  17 2017-05-01 00:00:00.000000    RNACEN             SILVA   \n",
       "39  30 2017-05-01 00:00:00.000000    RNACEN               ZWD   \n",
       "40  33 2017-05-01 00:00:00.000000    RNACEN           LNCBOOK   \n",
       "41  11 2017-05-01 00:00:00.000000    RNACEN              PDBE   \n",
       "42  16 2017-05-01 00:00:00.000000    RNACEN               SGD   \n",
       "43  18 2017-05-01 00:00:00.000000    RNACEN           POMBASE   \n",
       "44  23 2017-05-01 00:00:00.000000    RNACEN              HGNC   \n",
       "45  44 2017-05-01 00:00:00.000000    RNACEN              ZFIN   \n",
       "46  37 2017-05-01 00:00:00.000000    RNACEN             SNODB   \n",
       "47  13 2017-05-01 00:00:00.000000    RNACEN        GREENGENES   \n",
       "48  38 2017-05-01 00:00:00.000000    RNACEN          5SRRNADB   \n",
       "49  32 2017-05-01 00:00:00.000000    RNACEN           LNCBASE   \n",
       "50  29 2017-05-01 00:00:00.000000    RNACEN           TARBASE   \n",
       "51   4 2017-05-01 00:00:00.000000    RNACEN           MIRBASE   \n",
       "52  21 2017-05-02 00:00:00.000000    RNACEN           NONCODE   \n",
       "\n",
       "    current_release                        full_descr alive for_release  \\\n",
       "0                98                              VEGA     N        None   \n",
       "1               731                               ENA     Y        None   \n",
       "2               450                           GENCODE     N        None   \n",
       "3               732                             SRPDB     Y        None   \n",
       "4               735                          WormBase     Y        None   \n",
       "5               739                           FlyBase     Y        None   \n",
       "6               720                              TAIR     Y        None   \n",
       "7               635                              RFAM     Y        None   \n",
       "8               721                           Ensembl     Y        None   \n",
       "9               729                        Ribocentre     Y        None   \n",
       "10              730                         EVLncRNAs     Y        None   \n",
       "11              414                     tmRNA Website     Y        None   \n",
       "12              636                  Expression Atlas     Y        None   \n",
       "13              724                  Ensembl Protists     Y        None   \n",
       "14              725                     Ensembl Fungi     Y        None   \n",
       "15               92                          Modomics     Y        None   \n",
       "16              612                         LNCipedia     Y        None   \n",
       "17              194               Rat Genome Database     Y        None   \n",
       "18              174             Mouse Genome Database     Y        None   \n",
       "19              606                            PLncDB     Y        None   \n",
       "20              560                        RiboVision     Y        None   \n",
       "21              740                            IntAct     Y        None   \n",
       "22              632                          PSICQUIC     Y        None   \n",
       "23              723                   Ensembl Metazoa     Y        None   \n",
       "24              726                         MalaCards     Y        None   \n",
       "25              727                         MalaCards     Y        None   \n",
       "26              728                   ENSEMBL_GENCODE     Y        None   \n",
       "27               86                         dictyBase     Y        None   \n",
       "28              511                             snOPY     Y        None   \n",
       "29              485                           piRBase     Y        None   \n",
       "30              593                               CRW     Y        None   \n",
       "31              733                           GtRNAdb     Y        None   \n",
       "32              719                            RefSeq     Y        None   \n",
       "33              722                    Ensembl Plants     Y        None   \n",
       "34              446                   snoRNA Database     Y        None   \n",
       "35               85                               RDP     Y        None   \n",
       "36              464                          lncRNAdb     Y        None   \n",
       "37              559                         MirGeneDB     Y        None   \n",
       "38              610                             SILVA     Y        None   \n",
       "39              615                               ZWD     Y        None   \n",
       "40              616                           LncBook     Y        None   \n",
       "41              734                              PDBe     Y        None   \n",
       "42              736                               SGD     Y        None   \n",
       "43              737                           PomBase     Y        None   \n",
       "44              738  HUGO Gene Nomenclature Committee     Y        None   \n",
       "45              741                              ZFIN     Y        None   \n",
       "46              444                             snoDB     Y        None   \n",
       "47               71                        Greengenes     Y        None   \n",
       "48              387                          5SrRNAdb     Y        None   \n",
       "49              248                           LncBase     Y        None   \n",
       "50              223                           TarBase     Y        None   \n",
       "51              435                           MIRBASE     Y        None   \n",
       "52              146                           NONCODE     Y        None   \n",
       "\n",
       "        display_name  project_id  avg_length  min_length  max_length  \\\n",
       "0               VEGA   PRJEB4568         NaN         NaN         NaN   \n",
       "1                ENA        None       412.0        10.0    900074.0   \n",
       "2            GENCODE        None       889.0        32.0    205012.0   \n",
       "3              SRPDB   PRJEB4384       173.0        30.0       533.0   \n",
       "4           WormBase  PRJNA13758       174.0        17.0     84141.0   \n",
       "5            FlyBase     PRJ_FLY       765.0        18.0     21216.0   \n",
       "6               TAIR    PRJ_TAIR       384.0        19.0      6227.0   \n",
       "7               Rfam        None       135.0        24.0     11047.0   \n",
       "8            Ensembl        None       908.0        20.0    347561.0   \n",
       "9         Ribocentre        None        67.0        28.0      1619.0   \n",
       "10         EVLncRNAs        None      2311.0       199.0    205012.0   \n",
       "11     tmRNA Website   PRJEB4570       335.0        23.0       644.0   \n",
       "12  Expression Atlas        None       953.0        72.0     32709.0   \n",
       "13  Ensembl Protists        None       212.0        11.0      7940.0   \n",
       "14     Ensembl Fungi        None       210.0        19.0     16569.0   \n",
       "15          Modomics        None       140.0        54.0      5025.0   \n",
       "16         LNCipedia        None      1534.0       200.0    152544.0   \n",
       "17               RGD        None      2340.0        49.0     27956.0   \n",
       "18               MGI        None       851.0        21.0     84395.0   \n",
       "19            PLncDB        None      6659.0       199.0    985945.0   \n",
       "20        RiboVision        None      1676.0        30.0      5070.0   \n",
       "21            IntAct        None       705.0        18.0     93092.0   \n",
       "22          PSICQUIC        None      2251.0        21.0     84395.0   \n",
       "23   Ensembl Metazoa        None       712.0        18.0     46956.0   \n",
       "24         MalaCards        None      1861.0        16.0    220253.0   \n",
       "25         GeneCards        None      1301.0        16.0    347561.0   \n",
       "26   Ensembl/GENCODE        None      1274.0        32.0    347561.0   \n",
       "27         dictyBase   PRJ_DICTY        82.0        32.0      1060.0   \n",
       "28             snOPY   PRJEB8122       117.0        42.0      1004.0   \n",
       "29           piRBase        None        28.0        15.0        40.0   \n",
       "30               CRW        None      1365.0       107.0      4381.0   \n",
       "31           GtRNAdb   PRJEB5173        76.0        53.0       356.0   \n",
       "32            RefSeq        None       637.0        15.0     91671.0   \n",
       "33    Ensembl Plants        None       279.0        15.0     79788.0   \n",
       "34   snoRNA Database        None        50.0        45.0        74.0   \n",
       "35               RDP        None      1536.0      1337.0      1600.0   \n",
       "36          lncRNAdb   PRJEB6238      3086.0        61.0     32753.0   \n",
       "37         MirGeneDB        None        41.0        20.0       282.0   \n",
       "38             SILVA        None      1080.0       300.0      4997.0   \n",
       "39               ZWD        None        86.0        21.0       951.0   \n",
       "40           LncBook        None      1686.0        54.0    205012.0   \n",
       "41              PDBe        None       591.0        10.0     19000.0   \n",
       "42               SGD     PRJ_SGD       243.0        58.0      6858.0   \n",
       "43           PomBase  PRJNA13836       179.0        47.0      3485.0   \n",
       "44              HGNC        None      1058.0        33.0    205012.0   \n",
       "45              ZFIN        None       907.0        83.0     13525.0   \n",
       "46             snoDB        None       117.0        33.0       791.0   \n",
       "47        Greengenes        None      1403.0      1253.0      2368.0   \n",
       "48          5SrRNAdb        None       120.0        95.0       180.0   \n",
       "49           LncBase        None        22.0        17.0        26.0   \n",
       "50           TarBase        None        22.0        16.0        27.0   \n",
       "51           miRBase   PRJEB4451        55.0        15.0      2354.0   \n",
       "52           NONCODE        None      1130.0       201.0    244296.0   \n",
       "\n",
       "    num_sequences  num_organisms  \n",
       "0               0              0  \n",
       "1        12086180         814855  \n",
       "2           47677              2  \n",
       "3             503            684  \n",
       "4           26116              1  \n",
       "5            4210              1  \n",
       "6            4406              1  \n",
       "7         1872081          14735  \n",
       "8         1294678            264  \n",
       "9          151770           5536  \n",
       "10            933              3  \n",
       "11           2857           7560  \n",
       "12          11030              3  \n",
       "13           5261             32  \n",
       "14          15817             62  \n",
       "15            319             60  \n",
       "16         126876              1  \n",
       "17          11124              1  \n",
       "18          16719              1  \n",
       "19         936926             80  \n",
       "20             36             15  \n",
       "21            386              9  \n",
       "22             95              8  \n",
       "23         285241            152  \n",
       "24          57129              1  \n",
       "25         515365              1  \n",
       "26          76095              2  \n",
       "27            149              1  \n",
       "28           2501              7  \n",
       "29         200827             17  \n",
       "30            934            685  \n",
       "31          93098           4337  \n",
       "32         107976          22247  \n",
       "33          76428             59  \n",
       "34            680             10  \n",
       "35           4779           2487  \n",
       "36             62             10  \n",
       "37          18901             75  \n",
       "38        8193988         665540  \n",
       "39          44332           6763  \n",
       "40         322552              1  \n",
       "41           3760            382  \n",
       "42            212              1  \n",
       "43            200              1  \n",
       "44           8438              1  \n",
       "45           1025              1  \n",
       "46           1970              1  \n",
       "47        1004892          92684  \n",
       "48           9487           7158  \n",
       "49           1151              2  \n",
       "50           1291              2  \n",
       "51          65389            271  \n",
       "52         234669              7  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "vn.run_sql(sql=\"SELECT * FROM rnc_database\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Run as a Web App\n",
    "If you would like to use this functionality in a web app, you can deploy the Vanna Streamlit app and use your own secrets. See [this repo](https://github.com/vanna-ai/vanna-streamlit)."
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}
